<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.cyt.${module?replace('/','.')}.dao.${entity}Dao">

    <select id="selectVoList" parameterType="${entity}Vo" resultType="${entity}Vo">
        select t.*
        from ${table.sqlName} t
        where t.remove_tag = '1'
        <#list table.columns as column>
            <#if column.columnName!="RemoveTag" && column.columnName!="CreateUser" && column.columnName!="CreateTime" && column.columnName!="UpdateTime" && column.columnName!="UpdateUser">
        <if test="${column.columnNameLower} != null and ${column.columnNameLower} != ''">
            and t.${column.sqlName} = ${r'#{'}${column.columnNameLower}${r'}'}
        </if>
            </#if>
        </#list>
    </select>

    <select id="selectVoOne" parameterType="${entity}Vo" resultType="${entity}Vo">
        select t.*
        from ${table.sqlName} t
        where t.remove_tag = '1'
        <if test="id != null and id != ''">
            and t.id = ${r'#{id}'}
        </if>
    </select>

</mapper>